<?php
$installer = $this;
$installer->startSetup();
$installer->run("
ALTER TABLE {$this->getTable('shipping_ems')} DROP COLUMN dest_region_id;
ALTER TABLE {$this->getTable('shipping_ems')} DROP COLUMN dest_city;
ALTER TABLE {$this->getTable('shipping_ems')} DROP COLUMN dest_country_id;
ALTER TABLE {$this->getTable('shipping_ems')} ADD zone_id smallint(5);
");
$installer->endSetup();


